package com.itmayiedu.model.xmcyz;

import com.itmayiedu.model.test.Student;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.sql.Timestamp;

/**
 * Created by Devin on 2018/1/27.
 */
public interface TeacherMapper {

    @Select("SELECT * FROM st_teacher WHERE id = #{id}")
    Student findById(@Param("id") Integer id);

    @Insert("INSERT INTO st_teacher(`id`, `name`, `setx`, `create_time`) VALUES (null,#{name},#{sex},#{createTime});")
    int insert(@Param("name") String name, @Param("sex") String sex,@Param("createTime")Timestamp createTime);
}
